/*
 Navicat Premium Data Transfer

 Source Server         : energy
 Source Server Type    : MySQL
 Source Server Version : 50562
 Source Host           : 103.36.192.219:3308
 Source Schema         : gd-energy

 Target Server Type    : MySQL
 Target Server Version : 50562
 File Encoding         : 65001

 Date: 09/08/2020 20:57:03
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for energy_admin
-- ----------------------------
DROP TABLE IF EXISTS `energy_admin`;
CREATE TABLE `energy_admin` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `company_id` bigint(20) DEFAULT NULL,
  `create_date` datetime NOT NULL,
  `modify_date` datetime NOT NULL,
  `operator_id` bigint(20) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `is_enabled` bit(1) NOT NULL DEFAULT b'1',
  `is_locked` bit(1) NOT NULL DEFAULT b'1',
  `locked_date` datetime DEFAULT NULL,
  `login_date` datetime DEFAULT NULL,
  `login_failure_count` int(11) NOT NULL DEFAULT '0',
  `login_ip` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `username` varchar(100) NOT NULL,
  `company` varchar(255) DEFAULT NULL,
  `position` varchar(255) DEFAULT NULL,
  `tel_phone` varchar(255) DEFAULT NULL,
  `is_del` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除 0正常1删除',
  `energy_type` int(11) DEFAULT '0' COMMENT '类型0水表',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of energy_admin
-- ----------------------------
BEGIN;
INSERT INTO `energy_admin` VALUES (1, NULL, '2018-07-02 10:41:48', '2020-07-19 09:43:15', NULL, NULL, '1256985@qq.com', b'1', b'0', '2020-08-03 17:11:50', '2020-08-09 20:55:44', 1, '127.0.0.1', '超级管理员', '5169400c0a7e4cb221d28cbd964cd3a642874ab5', 'admin', NULL, NULL, '18751570619', b'0', 0);
INSERT INTO `energy_admin` VALUES (4, NULL, '2020-08-06 16:15:19', '2020-08-06 16:31:59', 1, 'string', 'string', b'1', b'0', NULL, NULL, 0, NULL, 'string', '1d54c8e86b06543bd07b3db6c006b7d2f5292f50', 'admin2', NULL, NULL, NULL, b'0', 0);
COMMIT;

-- ----------------------------
-- Table structure for energy_admin_role
-- ----------------------------
DROP TABLE IF EXISTS `energy_admin_role`;
CREATE TABLE `energy_admin_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL COMMENT '用户id',
  `role_id` int(11) NOT NULL COMMENT '角色id',
  `energy_type` int(11) DEFAULT '0' COMMENT '类型0，水表',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of energy_admin_role
-- ----------------------------
BEGIN;
INSERT INTO `energy_admin_role` VALUES (1, 1, 2, 0);
INSERT INTO `energy_admin_role` VALUES (10, 4, 1, 0);
INSERT INTO `energy_admin_role` VALUES (11, 4, 2, 0);
COMMIT;

-- ----------------------------
-- Table structure for energy_app_admin_detail
-- ----------------------------
DROP TABLE IF EXISTS `energy_app_admin_detail`;
CREATE TABLE `energy_app_admin_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `admin_id` bigint(20) DEFAULT NULL,
  `company_id` bigint(20) DEFAULT NULL,
  `create_date` datetime NOT NULL,
  `energy_type` int(11) DEFAULT '0',
  `is_del` bit(1) NOT NULL,
  `modify_date` datetime NOT NULL,
  `operator_id` bigint(20) DEFAULT NULL,
  `file_name` varchar(255) DEFAULT NULL,
  `file_path` longtext,
  `household_id` bigint(20) DEFAULT NULL,
  `nick_name` varchar(255) DEFAULT NULL,
  `balance` decimal(19,2) DEFAULT NULL,
  `over_money` decimal(19,2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `admin_id` (`admin_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of energy_app_admin_detail
-- ----------------------------
BEGIN;
INSERT INTO `energy_app_admin_detail` VALUES (2, 4, NULL, '2020-08-06 16:31:59', 0, b'0', '2020-08-06 16:31:59', 1, NULL, NULL, NULL, NULL, 2.00, 2.00);
COMMIT;

-- ----------------------------
-- Table structure for energy_area_archives
-- ----------------------------
DROP TABLE IF EXISTS `energy_area_archives`;
CREATE TABLE `energy_area_archives` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `company_id` bigint(20) DEFAULT NULL,
  `create_date` datetime NOT NULL,
  `energy_type` int(11) DEFAULT '0',
  `is_del` bit(1) NOT NULL DEFAULT b'0',
  `modify_date` datetime NOT NULL,
  `operator_id` bigint(20) DEFAULT NULL,
  `battery` varchar(255) DEFAULT NULL,
  `collect_channel` int(11) DEFAULT NULL,
  `control_value_address` varchar(255) DEFAULT NULL,
  `customer_address` varchar(255) DEFAULT NULL,
  `customer_certificate_number` varchar(255) DEFAULT NULL,
  `customer_certificate_type` int(11) NOT NULL,
  `customer_email` varchar(255) DEFAULT NULL,
  `customer_fee` decimal(21,6) NOT NULL,
  `customer_name` varchar(255) DEFAULT NULL,
  `customer_password` varchar(255) DEFAULT NULL,
  `customer_phone` varchar(255) DEFAULT NULL,
  `customer_serialnumber` varchar(100) NOT NULL,
  `customer_state` int(11) NOT NULL,
  `customer_tel` varchar(255) DEFAULT NULL,
  `customer_type` int(11) NOT NULL,
  `customer_use_state` int(11) DEFAULT NULL,
  `equipment_type` int(11) NOT NULL,
  `household_num` bigint(20) DEFAULT NULL,
  `lorawan_deveui` varchar(255) DEFAULT NULL,
  `measure_billing_type` int(11) NOT NULL,
  `measure_control_type` int(11) NOT NULL,
  `measure_name` varchar(255) DEFAULT NULL,
  `measure_overdraft_money` decimal(21,2) NOT NULL,
  `measure_warn_money` decimal(21,2) NOT NULL,
  `meter_flat` varchar(255) DEFAULT NULL,
  `meter_memo` varchar(255) DEFAULT NULL,
  `meter_peak` varchar(255) DEFAULT NULL,
  `meter_reading` varchar(255) DEFAULT NULL,
  `meter_tip` varchar(255) DEFAULT NULL,
  `meter_total` varchar(255) DEFAULT NULL,
  `meter_type` int(11) DEFAULT NULL,
  `meter_valley` varchar(255) DEFAULT NULL,
  `nbone_net_device_id` varchar(255) DEFAULT NULL,
  `nbonet_net_imei` varchar(15) DEFAULT NULL,
  `normal_day_dosage` varchar(255) DEFAULT NULL,
  `orea_name` varchar(255) DEFAULT NULL,
  `paymod` int(11) DEFAULT NULL,
  `reading` varchar(255) DEFAULT NULL,
  `runstate` int(11) NOT NULL,
  `serialnumber` varchar(100) NOT NULL,
  `snr` varchar(255) DEFAULT NULL,
  `sysconfig_equipment_model` bigint(20) DEFAULT NULL,
  `valve_state` int(11) DEFAULT NULL,
  `measure_area_org` bigint(20) NOT NULL COMMENT 'energy_area_organization表id',
  `measure_equip_collect` bigint(20) DEFAULT NULL COMMENT 'energy_equip_collect 表id',
  `measure_equip_concent` bigint(20) DEFAULT NULL COMMENT 'energy_equip_collect 表id',
  `measure_param_price` bigint(20) DEFAULT NULL COMMENT 'energy_param_price 表id',
  `sysconfig_meter_model` bigint(20) NOT NULL COMMENT 'energy_sysconfig_metermodel 表id',
  PRIMARY KEY (`id`),
  UNIQUE KEY `customer_serialnumber` (`customer_serialnumber`),
  UNIQUE KEY `serialnumber` (`serialnumber`),
  KEY `FKBB9B7098F3D6DF2A` (`measure_param_price`),
  KEY `FKBB9B7098AB891E93` (`measure_equip_concent`),
  KEY `FKBB9B7098AB58EC93` (`measure_equip_collect`),
  KEY `FKBB9B7098A5A7DFB4` (`sysconfig_meter_model`),
  KEY `FKBB9B709865A5412` (`measure_area_org`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of energy_area_archives
-- ----------------------------
BEGIN;
INSERT INTO `energy_area_archives` VALUES (1, NULL, '2020-06-20 12:10:44', 0, b'0', '2020-07-10 15:20:53', 1, NULL, 0, NULL, '国动物联', '6788', 0, NULL, 2780.000000, '日海水表310543', NULL, NULL, 'USER20200620121018', 1, NULL, 0, 1, 2, 1, NULL, 1, 1, '国栋水表310543', 0.00, 0.00, '0', NULL, '0', NULL, '0', NULL, 0, '0', NULL, '862437040310543', NULL, '中国江苏省无锡市', 0, '44.7600', 0, '20200620121001', NULL, 1, 2, 5, 1, 1, 7, 1);
INSERT INTO `energy_area_archives` VALUES (2, NULL, '2020-06-20 12:11:15', 0, b'0', '2020-07-10 15:20:44', 1, NULL, 0, NULL, '国动物联', '6788', 0, NULL, 0.000000, '日海水表310402', NULL, NULL, 'USER20200620121045', 1, NULL, 0, 1, 2, 1, NULL, 1, 1, '国栋水表310402', 0.00, 0.00, '0', NULL, '0', NULL, '0', NULL, 0, '0', NULL, '862437040310402', NULL, '中国江苏省无锡市', 0, '0.0000', 0, '20200620121102', NULL, 1, 2, 5, 1, 1, 7, 1);
INSERT INTO `energy_area_archives` VALUES (3, NULL, '2020-06-20 12:24:21', 0, b'0', '2020-07-10 15:20:34', 1, NULL, 0, NULL, '国动物联', '6788', 0, NULL, 0.000000, '日海水表047656', NULL, NULL, 'USER20200620122348', 1, NULL, 0, 1, 2, 1, NULL, 1, 1, '国动水表047656', 0.00, 0.00, '0', NULL, '0', NULL, '0', NULL, 0, '0', NULL, '869401040047656', NULL, '中国江苏省无锡市', 0, '0', 0, '20200620122403', NULL, 1, 0, 5, 1, 1, 7, 1);
INSERT INTO `energy_area_archives` VALUES (4, NULL, '2020-06-30 09:52:13', 0, b'0', '2020-07-10 16:21:05', 1, '3626', 0, NULL, '国动物联', '6788', 0, NULL, 0.000000, '日海水表310519', NULL, NULL, 'USER20200630095146', 1, NULL, 0, 1, 2, 1, NULL, 1, 1, '国动水表310519', 0.00, 0.00, '0', NULL, '0', NULL, '0', NULL, 0, '0', NULL, '862437040310519', NULL, '中国江苏省无锡市', 0, '0.0000', 0, '20200630095201', '31', 1, 2, 5, 1, 1, 7, 1);
INSERT INTO `energy_area_archives` VALUES (5, NULL, '2020-06-30 09:53:13', 0, b'0', '2020-08-07 15:24:35', 1, '3180', 0, NULL, '日海物联', '6788', 0, NULL, 300.000000, '日海水表310311', NULL, '15651500000', 'USER20200630095233', 1, NULL, 0, 1, 2, 5, NULL, 1, 1, '日海水表310311', 0.00, 0.00, '0', NULL, '0', NULL, '0', NULL, 0, '0', NULL, '862437040310311', NULL, '中国河南省商丘市', 0, '26.2100', 0, '20200630095202', '18', 1, 2, 8, 2, 2, 7, 1);
INSERT INTO `energy_area_archives` VALUES (6, NULL, '2020-06-30 09:53:50', 0, b'0', '2020-07-14 10:42:01', 1, '3634', 0, NULL, '国动物联', '6788', 0, NULL, 15.000000, '日海水表310469', NULL, NULL, 'USER20200630095316', 1, NULL, 0, 1, 2, 1, NULL, 1, 1, '国动水表310469', 0.00, 0.00, '0', NULL, '0', NULL, '0', NULL, 0, '0', NULL, '862437040310469', NULL, '中国江苏省无锡市', 0, '0.3000', 0, '20200630095203', '31', 1, 2, 5, 1, 1, 7, 1);
INSERT INTO `energy_area_archives` VALUES (7, NULL, '2020-06-30 09:54:59', 0, b'0', '2020-07-10 15:19:37', 1, NULL, 0, NULL, '国动物联', '6788', 0, NULL, 30.000000, '日海水表310337', NULL, NULL, 'USER20200630095433', 1, NULL, 0, 1, 2, 1, NULL, 1, 1, '国动水表310337', 0.00, 0.00, '0', NULL, '0', NULL, '0', NULL, 0, '0', NULL, '862437040310337', NULL, '中国江苏省无锡市', 0, '3.2400', 0, '20200630095204', NULL, 1, 2, 5, 1, 1, 7, 1);
INSERT INTO `energy_area_archives` VALUES (8, NULL, '2020-06-30 09:55:49', 0, b'0', '2020-08-07 15:23:56', 1, '3215', 0, NULL, '河南省商丘市', '6788', 0, NULL, 1676.560000, '日海水表310360', NULL, '15651500000', 'USER20200630095523', 1, NULL, 0, 1, 2, 5, NULL, 0, 1, '日海水表310360', 0.00, 0.00, '0', NULL, '0', NULL, '0', NULL, 0, '0', NULL, '862437040310360', NULL, '中国河南省商丘市', 0, '1.8600', 0, '20200630095205', '23', 1, 2, 8, 2, 2, 14, 1);
INSERT INTO `energy_area_archives` VALUES (9, NULL, '2020-07-08 14:18:40', 0, b'0', '2020-07-09 16:42:55', 1, NULL, 0, NULL, 'A1-101', '320101111111111111', 0, NULL, -100.000000, 'A1-101', NULL, '15600000000', 'USER20200708141735', 1, NULL, 0, 1, 2, 2, NULL, 1, 1, 'A1-101', 0.00, 0.00, '0', NULL, '0', NULL, '0', NULL, NULL, '0', NULL, NULL, NULL, '河南', 0, '0', 0, 'aaaaaaaaaaaaaa', NULL, 1, 0, 3, 2, 2, 7, 1);
COMMIT;

-- ----------------------------
-- Table structure for energy_area_organization
-- ----------------------------
DROP TABLE IF EXISTS `energy_area_organization`;
CREATE TABLE `energy_area_organization` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `company_id` bigint(20) DEFAULT NULL,
  `create_date` datetime NOT NULL,
  `energy_type` int(11) DEFAULT '0' COMMENT '0水表',
  `is_del` bit(1) NOT NULL DEFAULT b'0',
  `modify_date` datetime NOT NULL,
  `operator_id` bigint(20) DEFAULT NULL,
  `area_contact_mail` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `area_contact_name` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `area_contact_phone` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `area_contact_tel` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `area_map_latitude` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `area_map_longitude` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `parent_id` bigint(20) DEFAULT NULL,
  `area_serialnumber` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `is_day_settlement` int(11) DEFAULT NULL,
  `is_send_sms` int(11) DEFAULT NULL,
  `settlement_day` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='区域';

-- ----------------------------
-- Records of energy_area_organization
-- ----------------------------
BEGIN;
INSERT INTO `energy_area_organization` VALUES (1, NULL, '2020-03-29 14:00:55', 0, b'0', '2020-03-29 14:04:01', 1, NULL, NULL, NULL, NULL, NULL, NULL, '中国', 0, 'AREA20200329140036', 0, 0, '25');
INSERT INTO `energy_area_organization` VALUES (2, NULL, '2020-03-29 14:01:20', 0, b'0', '2020-07-03 09:07:57', 1, NULL, NULL, NULL, NULL, '32.066776944293416', '118.76955164466914', '江苏省', 1, 'AREA20200329140100', 0, 0, '25');
INSERT INTO `energy_area_organization` VALUES (3, NULL, '2020-07-08 14:08:49', 0, b'0', '2020-07-10 06:35:25', 1, NULL, NULL, NULL, NULL, '34.740396071091155', '101.62247338027404', '河南', 0, 'AREA20200708140831', 0, 0, '1');
INSERT INTO `energy_area_organization` VALUES (5, NULL, '2020-07-08 15:12:33', 0, b'0', '2020-07-19 19:23:44', 1, NULL, NULL, NULL, NULL, '31.498809732685714', '120.31858328810601', '无锡市', 2, 'AREA20200708151213', 1, 1, '1');
INSERT INTO `energy_area_organization` VALUES (6, NULL, '2020-07-08 15:15:09', 0, b'0', '2020-07-08 15:15:09', 1, NULL, NULL, NULL, NULL, NULL, NULL, '上海市', 1, 'AREA20200708151459', 1, 1, '5');
INSERT INTO `energy_area_organization` VALUES (7, NULL, '2020-07-08 15:16:29', 0, b'0', '2020-07-08 15:16:29', 1, NULL, NULL, NULL, NULL, NULL, NULL, '河南省', 1, 'AREA20200708151615', 1, 1, '10');
INSERT INTO `energy_area_organization` VALUES (8, NULL, '2020-07-08 15:16:55', 0, b'0', '2020-07-19 19:23:19', 1, NULL, NULL, NULL, NULL, '34.4202016658586', '115.66244933826238', '商丘市', 7, 'AREA20200708151633', 1, 1, '20');
COMMIT;

-- ----------------------------
-- Table structure for energy_equip_collect
-- ----------------------------
DROP TABLE IF EXISTS `energy_equip_collect`;
CREATE TABLE `energy_equip_collect` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `company_id` bigint(20) DEFAULT NULL,
  `create_date` datetime NOT NULL,
  `energy_type` int(11) DEFAULT '0',
  `is_del` bit(1) NOT NULL DEFAULT b'0',
  `modify_date` datetime NOT NULL,
  `operator_id` bigint(20) DEFAULT NULL,
  `all_meter_address` longtext,
  `arrears` int(11) DEFAULT NULL,
  `battery_state` varchar(255) DEFAULT NULL,
  `clock_state` varchar(255) DEFAULT NULL,
  `collect_capacity` int(11) NOT NULL,
  `collect_name` varchar(255) DEFAULT NULL,
  `collect_serialnumber` varchar(100) NOT NULL,
  `collector_state` varchar(255) DEFAULT NULL,
  `d_meter_reading` varchar(255) DEFAULT NULL,
  `electric_supply` varchar(255) DEFAULT NULL,
  `equipment_collect_type` int(11) NOT NULL,
  `flash_state` varchar(255) DEFAULT NULL,
  `is_wifi` int(11) DEFAULT NULL,
  `large_flow` int(11) DEFAULT NULL,
  `mbus_state` varchar(255) DEFAULT NULL,
  `operation_state` varchar(255) DEFAULT NULL,
  `paymod` int(11) DEFAULT NULL,
  `soft_time` varchar(255) DEFAULT NULL,
  `soft_version` varchar(255) DEFAULT NULL,
  `sram_state` varchar(255) DEFAULT NULL,
  `t_meter_reading` varchar(255) DEFAULT NULL,
  `water_level` int(11) NOT NULL,
  `water_supply_company` varchar(255) DEFAULT NULL,
  `area_org` bigint(20) DEFAULT NULL COMMENT 'energy_area_organization 表id',
  `equip_concent` bigint(20) DEFAULT NULL COMMENT 'energy_equip_concent 表id',
  `meter_mul` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK628BC95095619E51` (`area_org`),
  KEY `FK628BC9501B0163B4` (`equip_concent`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of energy_equip_collect
-- ----------------------------
BEGIN;
INSERT INTO `energy_equip_collect` VALUES (3, NULL, '2020-06-20 12:08:54', 0, b'0', '2020-07-10 20:21:37', 1, '', 0, NULL, NULL, 0, '日海电信水表#集中器', '1', NULL, NULL, NULL, 2, NULL, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, 1, 1);
INSERT INTO `energy_equip_collect` VALUES (4, NULL, '2020-07-08 14:16:32', 0, b'0', '2020-07-10 15:04:03', 1, '', 0, NULL, NULL, 0, '演示小区', '2', NULL, NULL, NULL, 2, NULL, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, 2, 1);
COMMIT;

-- ----------------------------
-- Table structure for energy_equip_concent
-- ----------------------------
DROP TABLE IF EXISTS `energy_equip_concent`;
CREATE TABLE `energy_equip_concent` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `company_id` bigint(20) DEFAULT NULL,
  `create_date` datetime NOT NULL,
  `energy_type` int(11) DEFAULT '0',
  `is_del` bit(1) NOT NULL DEFAULT b'0',
  `modify_date` datetime NOT NULL,
  `operator_id` bigint(20) DEFAULT NULL,
  `conncent_name` varchar(255) DEFAULT NULL,
  `conncent_serialnumber` varchar(100) NOT NULL,
  `connect_sim_card` varchar(255) DEFAULT NULL,
  `equipment_agree` int(11) NOT NULL,
  `equipment_connect_type` int(11) NOT NULL,
  `equipment_downside` int(11) NOT NULL,
  `equipmentnbtype` int(11) DEFAULT NULL,
  `equipment_state` int(11) NOT NULL,
  `equipment_type` int(11) NOT NULL,
  `equipment_upside` int(11) NOT NULL,
  `handling_date` varchar(255) DEFAULT NULL,
  `installation_date` varchar(255) DEFAULT NULL,
  `is_virtual` int(11) NOT NULL,
  `memo` longtext,
  `normal_day_dosage` bigint(20) DEFAULT NULL,
  `area_org` bigint(20) NOT NULL COMMENT '关联energy_area_organization表id',
  `sysconfig_equipment_model` bigint(20) DEFAULT NULL COMMENT '关联energy_sysconfig_equipmentmodel表id',
  `sysconfig_supplier` bigint(20) DEFAULT NULL COMMENT '关联energy_sysconfig_supplier表id',
  PRIMARY KEY (`id`),
  UNIQUE KEY `conncent_serialnumber` (`conncent_serialnumber`),
  KEY `FK62A3E25025FAA959` (`sysconfig_supplier`),
  KEY `FK62A3E25040BB4A94` (`sysconfig_equipment_model`),
  KEY `FK62A3E25095619E51` (`area_org`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of energy_equip_concent
-- ----------------------------
BEGIN;
INSERT INTO `energy_equip_concent` VALUES (3, NULL, '2020-06-20 12:08:44', 0, b'0', '2020-07-10 20:20:48', 1, '日海电信水表#集中器', '2020062001', '2020062001', 4, 0, 3, 4, 0, 2, 0, NULL, NULL, 0, '', NULL, 5, 1, 3);
INSERT INTO `energy_equip_concent` VALUES (4, NULL, '2020-07-08 14:15:19', 0, b'0', '2020-07-10 20:31:24', 1, '日海水表', '2020062002', '2020062002', 5, 0, 3, 4, 0, 2, 0, '2020-07-02', '2020-07-01', 0, '', NULL, 8, 1, 4);
COMMIT;

-- ----------------------------
-- Table structure for energy_log
-- ----------------------------
DROP TABLE IF EXISTS `energy_log`;
CREATE TABLE `energy_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `company_id` bigint(20) DEFAULT NULL,
  `create_date` datetime NOT NULL,
  `energy_type` int(11) DEFAULT '0',
  `is_del` bit(1) NOT NULL DEFAULT b'0',
  `modify_date` datetime NOT NULL,
  `operator_id` bigint(20) DEFAULT NULL,
  `content` longtext,
  `ip` varchar(255) NOT NULL,
  `operation` varchar(255) NOT NULL,
  `operator` varchar(255) DEFAULT NULL,
  `parameter` longtext,
  PRIMARY KEY (`id`),
  KEY `energy_log_is_del_IDX` (`is_del`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=154 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of energy_log
-- ----------------------------
BEGIN;
INSERT INTO `energy_log` VALUES (35, NULL, '2020-08-07 12:38:12', 1, b'0', '2020-08-07 12:38:12', NULL, NULL, '10.80.19.75', '登录', 'admin', '[{\"code\":\"string\",\"sessionId\":\"string\",\"password\":\"admin\",\"username\":\"admin\"}]');
INSERT INTO `energy_log` VALUES (36, NULL, '2020-08-07 12:38:31', 1, b'0', '2020-08-07 12:38:31', NULL, NULL, '10.80.19.75', '获取目录、菜单、权限列表', 'admin', '[]');
INSERT INTO `energy_log` VALUES (37, NULL, '2020-08-07 14:48:04', 1, b'0', '2020-08-07 14:48:04', NULL, NULL, '10.80.19.75', '登录', 'admin', '[{\"code\":\"string\",\"sessionId\":\"string\",\"password\":\"admin\",\"username\":\"admin\"}]');
INSERT INTO `energy_log` VALUES (38, NULL, '2020-08-07 14:50:27', 1, b'0', '2020-08-07 14:50:27', NULL, NULL, '10.80.19.75', '获取当前用户拥有的目录、菜单、权限列表', 'admin', '[]');
INSERT INTO `energy_log` VALUES (39, NULL, '2020-08-07 14:51:17', 1, b'0', '2020-08-07 14:51:17', NULL, NULL, '10.80.19.75', '获取当前用户拥有的目录、菜单、权限列表', 'admin', '[]');
INSERT INTO `energy_log` VALUES (40, NULL, '2020-08-07 14:52:35', 1, b'0', '2020-08-07 14:52:35', NULL, NULL, '10.80.19.75', '获取当前用户拥有的目录、菜单、权限列表', 'admin', '[]');
INSERT INTO `energy_log` VALUES (41, NULL, '2020-08-07 16:56:30', 0, b'0', '2020-08-07 16:56:30', NULL, NULL, '10.80.19.75', '登录', 'admin', '[{\"code\":\"string\",\"sessionId\":\"string\",\"password\":\"admin\",\"username\":\"admin\"}]');
INSERT INTO `energy_log` VALUES (42, NULL, '2020-08-07 16:58:01', 0, b'0', '2020-08-07 16:58:01', NULL, NULL, '10.80.19.75', '客户缴费管理分页列表', 'admin', '[10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (43, NULL, '2020-08-07 16:58:32', 0, b'0', '2020-08-07 16:58:32', NULL, NULL, '10.80.19.75', '客户缴费管理分页列表', 'admin', '[\"156\",10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (44, NULL, '2020-08-07 16:58:46', 0, b'0', '2020-08-07 16:58:46', NULL, NULL, '10.80.19.75', '客户缴费管理分页列表', 'admin', '[5,10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (45, NULL, '2020-08-07 16:59:01', 0, b'0', '2020-08-07 16:59:01', NULL, NULL, '10.80.19.75', '客户缴费管理分页列表', 'admin', '[1,10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (46, NULL, '2020-08-07 21:01:42', 0, b'0', '2020-08-07 21:01:42', NULL, NULL, '127.0.0.1', '登录', 'admin', '[{\"code\":\"string\",\"sessionId\":\"string\",\"password\":\"admin\",\"username\":\"admin\"}]');
INSERT INTO `energy_log` VALUES (47, NULL, '2020-08-07 21:06:18', 0, b'0', '2020-08-07 21:06:18', NULL, NULL, '127.0.0.1', '获取缴费信息', 'admin', '[11]');
INSERT INTO `energy_log` VALUES (48, NULL, '2020-08-08 09:37:16', 0, b'0', '2020-08-08 09:37:16', NULL, NULL, '127.0.0.1', '登录', 'admin', '[{\"code\":\"string\",\"sessionId\":\"string\",\"password\":\"admin\",\"username\":\"admin\"}]');
INSERT INTO `energy_log` VALUES (49, NULL, '2020-08-08 09:37:35', 0, b'0', '2020-08-08 09:37:35', NULL, NULL, '127.0.0.1', '客户缴费管理分页列表', 'admin', '[10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (50, NULL, '2020-08-08 09:37:49', 0, b'0', '2020-08-08 09:37:49', NULL, NULL, '127.0.0.1', '获取缴费信息', 'admin', '[18]');
INSERT INTO `energy_log` VALUES (51, NULL, '2020-08-08 09:38:26', 0, b'0', '2020-08-08 09:38:26', NULL, NULL, '127.0.0.1', '更新缴费', 'admin', '[{\"receNumber\":\"SJBH20200808093749\",\"fee\":\"18.12\",\"id\":18}]');
INSERT INTO `energy_log` VALUES (52, NULL, '2020-08-08 09:43:53', 0, b'0', '2020-08-08 09:43:53', NULL, NULL, '127.0.0.1', '更新缴费', 'admin', '[{\"receNumber\":\"SJBH20200808093749\",\"fee\":\"18.12\",\"id\":18}]');
INSERT INTO `energy_log` VALUES (53, NULL, '2020-08-08 10:04:40', 0, b'0', '2020-08-08 10:04:40', NULL, NULL, '49.66.73.205', '登录', 'admin', '[{\"code\":\"amg2\",\"sessionId\":\"aef5fd51-656c-4217-8282-01f0c1b0ba7e\",\"password\":\"admin\",\"username\":\"admin\"}]');
INSERT INTO `energy_log` VALUES (54, NULL, '2020-08-08 10:04:52', 0, b'0', '2020-08-08 10:04:52', NULL, NULL, '49.66.73.205', '客户缴费管理分页列表', 'admin', '[10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (55, NULL, '2020-08-08 10:05:06', 0, b'0', '2020-08-08 10:05:06', NULL, NULL, '49.66.73.205', '获取缴费信息', 'admin', '[19]');
INSERT INTO `energy_log` VALUES (56, NULL, '2020-08-08 10:05:51', 0, b'0', '2020-08-08 10:05:51', NULL, NULL, '49.66.73.205', '更新缴费', 'admin', '[{\"receNumber\":\"SJBH20200808100506\",\"fee\":\"12\",\"id\":19}]');
INSERT INTO `energy_log` VALUES (57, NULL, '2020-08-08 10:06:11', 0, b'0', '2020-08-08 10:06:11', NULL, NULL, '49.66.73.205', '获取缴费信息', 'admin', '[19]');
INSERT INTO `energy_log` VALUES (58, NULL, '2020-08-08 10:09:41', 0, b'0', '2020-08-08 10:09:41', NULL, NULL, '127.0.0.1', '登录', 'admin', '[{\"code\":\"string\",\"sessionId\":\"string\",\"password\":\"admin\",\"username\":\"admin\"}]');
INSERT INTO `energy_log` VALUES (59, NULL, '2020-08-08 10:09:57', 0, b'0', '2020-08-08 10:09:57', NULL, NULL, '127.0.0.1', '获取缴费信息', 'admin', '[18]');
INSERT INTO `energy_log` VALUES (60, NULL, '2020-08-08 10:10:27', 0, b'0', '2020-08-08 10:10:27', NULL, NULL, '127.0.0.1', '更新缴费', 'admin', '[{\"receNumber\":\"SJBH20200808100957\",\"fee\":\"11.2\",\"id\":18}]');
INSERT INTO `energy_log` VALUES (61, NULL, '2020-08-08 17:36:14', 0, b'0', '2020-08-08 17:36:14', NULL, NULL, '127.0.0.1', '登录', 'admin', '[{\"code\":\"string\",\"sessionId\":\"string\",\"password\":\"admin\",\"username\":\"admin\"}]');
INSERT INTO `energy_log` VALUES (62, NULL, '2020-08-08 17:37:26', 0, b'0', '2020-08-08 17:37:26', NULL, NULL, '127.0.0.1', '获取缴费信息', 'admin', '[18]');
INSERT INTO `energy_log` VALUES (63, NULL, '2020-08-08 17:37:42', 0, b'0', '2020-08-08 17:37:42', NULL, NULL, '127.0.0.1', '保存退费', 'admin', '[{\"receNumber\":\"SJBH20200808173726\",\"fee\":\"12\",\"id\":18}]');
INSERT INTO `energy_log` VALUES (64, NULL, '2020-08-08 17:38:27', 0, b'0', '2020-08-08 17:38:27', NULL, NULL, '127.0.0.1', '获取缴费信息', 'admin', '[18]');
INSERT INTO `energy_log` VALUES (65, NULL, '2020-08-08 19:56:30', 0, b'0', '2020-08-08 19:56:30', NULL, NULL, '127.0.0.1', '登录', 'admin', '[{\"code\":\"string\",\"sessionId\":\"string\",\"password\":\"admin\",\"username\":\"admin\"}]');
INSERT INTO `energy_log` VALUES (66, NULL, '2020-08-08 19:56:53', 0, b'0', '2020-08-08 19:56:53', NULL, NULL, '127.0.0.1', '余额查询', 'admin', '[10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (67, NULL, '2020-08-08 20:19:43', 0, b'0', '2020-08-08 20:19:43', NULL, NULL, '127.0.0.1', '登录', 'admin', '[{\"code\":\"string\",\"sessionId\":\"string\",\"password\":\"admin\",\"username\":\"admin\"}]');
INSERT INTO `energy_log` VALUES (68, NULL, '2020-08-08 20:20:55', 0, b'0', '2020-08-08 20:20:55', NULL, NULL, '127.0.0.1', '余额查询', 'admin', '[10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (69, NULL, '2020-08-08 20:21:27', 0, b'0', '2020-08-08 20:21:27', NULL, NULL, '127.0.0.1', '欠费查询', 'admin', '[10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (70, NULL, '2020-08-08 20:21:44', 0, b'0', '2020-08-08 20:21:44', NULL, NULL, '127.0.0.1', '余额查询', 'admin', '[\"10\",10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (71, NULL, '2020-08-09 12:18:35', 0, b'0', '2020-08-09 12:18:35', NULL, NULL, '127.0.0.1', '登录', 'admin', '[{\"code\":\"string\",\"sessionId\":\"string\",\"password\":\"admin\",\"username\":\"admin\"}]');
INSERT INTO `energy_log` VALUES (72, NULL, '2020-08-09 12:20:48', 0, b'0', '2020-08-09 12:20:48', NULL, NULL, '127.0.0.1', '收费统计分页列表', 'admin', '[10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (73, NULL, '2020-08-09 12:24:25', 0, b'0', '2020-08-09 12:24:25', NULL, NULL, '127.0.0.1', '收费统计分页列表', 'admin', '[10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (74, NULL, '2020-08-09 12:34:12', 0, b'0', '2020-08-09 12:34:12', NULL, NULL, '127.0.0.1', '收费统计分页列表', 'admin', '[10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (75, NULL, '2020-08-09 13:07:31', 0, b'0', '2020-08-09 13:07:31', NULL, NULL, '127.0.0.1', '登录', 'admin', '[{\"code\":\"string\",\"sessionId\":\"string\",\"password\":\"admin\",\"username\":\"admin\"}]');
INSERT INTO `energy_log` VALUES (76, NULL, '2020-08-09 13:07:51', 0, b'0', '2020-08-09 13:07:51', NULL, NULL, '127.0.0.1', '收费统计分页列表', 'admin', '[10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (77, NULL, '2020-08-09 13:09:29', 0, b'0', '2020-08-09 13:09:29', NULL, NULL, '127.0.0.1', '收费统计分页列表', 'admin', '[10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (78, NULL, '2020-08-09 13:11:33', 0, b'0', '2020-08-09 13:11:33', NULL, NULL, '127.0.0.1', '登录', 'admin', '[{\"code\":\"string\",\"sessionId\":\"string\",\"password\":\"admin\",\"username\":\"admin\"}]');
INSERT INTO `energy_log` VALUES (79, NULL, '2020-08-09 13:11:43', 0, b'0', '2020-08-09 13:11:43', NULL, NULL, '127.0.0.1', '收费统计分页列表', 'admin', '[10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (80, NULL, '2020-08-09 13:12:48', 0, b'0', '2020-08-09 13:12:48', NULL, NULL, '127.0.0.1', '收费统计分页列表', 'admin', '[\"3\",\"2020\",10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (81, NULL, '2020-08-09 13:12:55', 0, b'0', '2020-08-09 13:12:55', NULL, NULL, '127.0.0.1', '收费统计分页列表', 'admin', '[\"3\",\"2019\",10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (82, NULL, '2020-08-09 13:16:06', 0, b'0', '2020-08-09 13:16:06', NULL, NULL, '127.0.0.1', '收费统计分页列表', 'admin', '[\"3\",\"2019\",1,10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (83, NULL, '2020-08-09 13:16:15', 0, b'0', '2020-08-09 13:16:15', NULL, NULL, '127.0.0.1', '收费统计分页列表', 'admin', '[\"3\",\"2020\",1,10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (84, NULL, '2020-08-09 13:16:57', 0, b'0', '2020-08-09 13:16:57', NULL, NULL, '127.0.0.1', '收费统计分页列表', 'admin', '[1,\"3\",\"2020\",1,10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (85, NULL, '2020-08-09 13:17:06', 0, b'0', '2020-08-09 13:17:06', NULL, NULL, '127.0.0.1', '收费统计分页列表', 'admin', '[2,\"3\",\"2020\",1,10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (86, NULL, '2020-08-09 13:17:28', 0, b'0', '2020-08-09 13:17:28', NULL, NULL, '127.0.0.1', '收费统计分页列表', 'admin', '[\"3\",\"2020\",10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (87, NULL, '2020-08-09 13:17:38', 0, b'0', '2020-08-09 13:17:38', NULL, NULL, '127.0.0.1', '收费统计分页列表', 'admin', '[\"3\",\"2020\",0,10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (88, NULL, '2020-08-09 13:17:45', 0, b'0', '2020-08-09 13:17:45', NULL, NULL, '127.0.0.1', '收费统计分页列表', 'admin', '[\"3\",\"2020\",0,1,10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (89, NULL, '2020-08-09 13:17:50', 0, b'0', '2020-08-09 13:17:50', NULL, NULL, '127.0.0.1', '收费统计分页列表', 'admin', '[\"3\",\"2020\",0,1,10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (90, NULL, '2020-08-09 13:18:13', 0, b'0', '2020-08-09 13:18:13', NULL, NULL, '127.0.0.1', '收费统计分页列表', 'admin', '[\"3\",\"2020\",0,1,10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (91, NULL, '2020-08-09 13:18:16', 0, b'0', '2020-08-09 13:18:16', NULL, NULL, '127.0.0.1', '收费统计分页列表', 'admin', '[\"3\",\"2020\",0,0,10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (92, NULL, '2020-08-09 13:21:04', 0, b'0', '2020-08-09 13:21:04', NULL, NULL, '127.0.0.1', '收费统计分页列表', 'admin', '[\"3\",\"2020\",0,0,1,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (93, NULL, '2020-08-09 13:21:09', 0, b'0', '2020-08-09 13:21:09', NULL, NULL, '127.0.0.1', '收费统计分页列表', 'admin', '[\"3\",\"2020\",0,0,1,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (94, NULL, '2020-08-09 13:21:19', 0, b'0', '2020-08-09 13:21:19', NULL, NULL, '127.0.0.1', '收费统计分页列表', 'admin', '[\"3\",\"2020\",1,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (95, NULL, '2020-08-09 13:21:29', 0, b'0', '2020-08-09 13:21:29', NULL, NULL, '127.0.0.1', '收费统计分页列表', 'admin', '[\"3\",\"2020\",10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (96, NULL, '2020-08-09 13:22:29', 0, b'0', '2020-08-09 13:22:29', NULL, NULL, '127.0.0.1', '收费统计分页列表', 'admin', '[\"3\",\"2020\",10,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (97, NULL, '2020-08-09 13:22:36', 0, b'0', '2020-08-09 13:22:36', NULL, NULL, '127.0.0.1', '收费统计分页列表', 'admin', '[\"3\",\"2020\",0,1,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (98, NULL, '2020-08-09 13:24:05', 0, b'0', '2020-08-09 13:24:05', NULL, NULL, '127.0.0.1', '收费统计分页列表', 'admin', '[\"3\",\"2020\",0,1,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (99, NULL, '2020-08-09 13:24:41', 0, b'0', '2020-08-09 13:24:41', NULL, NULL, '127.0.0.1', '收费统计分页列表', 'admin', '[\"3\",\"2020\",0,1,1,\"id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (100, NULL, '2020-08-09 13:27:40', 0, b'0', '2020-08-09 13:27:40', NULL, NULL, '127.0.0.1', '获取所有管理员列表', 'admin', '[]');
INSERT INTO `energy_log` VALUES (101, NULL, '2020-08-09 14:15:58', 0, b'0', '2020-08-09 14:15:58', NULL, NULL, '127.0.0.1', '登录', 'admin', '[{\"code\":\"string\",\"sessionId\":\"string\",\"password\":\"admin\",\"username\":\"admin\"}]');
INSERT INTO `energy_log` VALUES (102, NULL, '2020-08-09 14:19:56', 0, b'0', '2020-08-09 14:19:56', NULL, NULL, '127.0.0.1', '登录', 'admin', '[{\"code\":\"string\",\"sessionId\":\"string\",\"password\":\"admin\",\"username\":\"admin\"}]');
INSERT INTO `energy_log` VALUES (103, NULL, '2020-08-09 14:20:07', 0, b'0', '2020-08-09 14:20:07', NULL, NULL, '127.0.0.1', '登录', 'admin', '[{\"code\":\"string\",\"sessionId\":\"string\",\"password\":\"admin\",\"username\":\"admin\"}]');
INSERT INTO `energy_log` VALUES (104, NULL, '2020-08-09 14:22:10', 0, b'0', '2020-08-09 14:22:10', NULL, NULL, '127.0.0.1', '收费查询分页列表', 'admin', '[10,1,\"a.id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (105, NULL, '2020-08-09 14:22:44', 0, b'0', '2020-08-09 14:22:44', NULL, NULL, '127.0.0.1', '收费查询分页列表', 'admin', '[10,1,\"paychannel\",\"asc \"]');
INSERT INTO `energy_log` VALUES (106, NULL, '2020-08-09 14:23:06', 0, b'0', '2020-08-09 14:23:06', NULL, NULL, '127.0.0.1', '收费查询分页列表', 'admin', '[10,1,\"payTime\",\"desc\"]');
INSERT INTO `energy_log` VALUES (107, NULL, '2020-08-09 14:49:41', 0, b'0', '2020-08-09 14:49:41', NULL, NULL, '192.168.0.105', '登录', 'admin', '[{\"code\":\"string\",\"sessionId\":\"string\",\"password\":\"admin\",\"username\":\"admin\"}]');
INSERT INTO `energy_log` VALUES (108, NULL, '2020-08-09 14:50:15', 0, b'0', '2020-08-09 14:50:15', NULL, NULL, '192.168.0.105', '收费查询分页列表-excel导出', 'admin', '[\"a.id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (109, NULL, '2020-08-09 14:54:50', 0, b'0', '2020-08-09 14:54:50', NULL, NULL, '192.168.0.105', '收费查询分页列表-excel导出', 'admin', '[\"a.id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (110, NULL, '2020-08-09 14:56:56', 0, b'0', '2020-08-09 14:56:56', NULL, NULL, '192.168.0.105', '收费查询分页列表-excel导出', 'admin', '[\"a.id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (111, NULL, '2020-08-09 14:58:58', 0, b'0', '2020-08-09 14:58:58', NULL, NULL, '192.168.0.105', '登录', 'admin', '[{\"code\":\"string\",\"sessionId\":\"string\",\"password\":\"admin\",\"username\":\"admin\"}]');
INSERT INTO `energy_log` VALUES (112, NULL, '2020-08-09 14:59:18', 0, b'0', '2020-08-09 14:59:18', NULL, NULL, '192.168.0.105', '收费查询分页列表-excel导出', 'admin', '[\"a.id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (113, NULL, '2020-08-09 15:03:35', 0, b'0', '2020-08-09 15:03:35', NULL, NULL, '192.168.0.105', '登录', 'admin', '[{\"code\":\"string\",\"sessionId\":\"string\",\"password\":\"admin\",\"username\":\"admin\"}]');
INSERT INTO `energy_log` VALUES (114, NULL, '2020-08-09 15:04:03', 0, b'0', '2020-08-09 15:04:03', NULL, NULL, '192.168.0.105', '收费查询分页列表-excel导出', 'admin', '[\"a.id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (115, NULL, '2020-08-09 15:08:42', 0, b'0', '2020-08-09 15:08:42', NULL, NULL, '192.168.0.105', '收费查询分页列表-excel导出', 'admin', '[\"a.id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (116, NULL, '2020-08-09 15:11:05', 0, b'0', '2020-08-09 15:11:05', NULL, NULL, '192.168.0.105', '收费查询分页列表-excel导出', 'admin', '[\"a.id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (117, NULL, '2020-08-09 15:12:02', 0, b'0', '2020-08-09 15:12:02', NULL, NULL, '192.168.0.105', '收费查询分页列表-excel导出', 'admin', '[\"a.id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (118, NULL, '2020-08-09 15:13:14', 0, b'0', '2020-08-09 15:13:14', NULL, NULL, '192.168.0.105', '登录', 'admin', '[{\"code\":\"string\",\"sessionId\":\"string\",\"password\":\"admin\",\"username\":\"admin\"}]');
INSERT INTO `energy_log` VALUES (119, NULL, '2020-08-09 15:13:28', 0, b'0', '2020-08-09 15:13:28', NULL, NULL, '192.168.0.105', '收费查询分页列表-excel导出', 'admin', '[\"a.id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (120, NULL, '2020-08-09 15:15:21', 0, b'0', '2020-08-09 15:15:21', NULL, NULL, '192.168.0.105', '收费查询分页列表-excel导出', 'admin', '[\"a.id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (121, NULL, '2020-08-09 15:16:23', 0, b'0', '2020-08-09 15:16:23', NULL, NULL, '192.168.0.105', '收费查询分页列表-excel导出', 'admin', '[\"a.id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (122, NULL, '2020-08-09 15:16:35', 0, b'0', '2020-08-09 15:16:35', NULL, NULL, '192.168.0.105', '收费查询分页列表-excel导出', 'admin', '[\"a.id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (123, NULL, '2020-08-09 15:17:06', 0, b'0', '2020-08-09 15:17:06', NULL, NULL, '192.168.0.105', '收费查询分页列表-excel导出', 'admin', '[\"a.id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (124, NULL, '2020-08-09 15:17:59', 0, b'0', '2020-08-09 15:17:59', NULL, NULL, '192.168.0.105', '收费查询分页列表-excel导出', 'admin', '[\"a.id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (125, NULL, '2020-08-09 15:19:45', 0, b'0', '2020-08-09 15:19:45', NULL, NULL, '192.168.0.105', '收费查询分页列表-excel导出', 'admin', '[\"a.id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (126, NULL, '2020-08-09 15:20:40', 0, b'0', '2020-08-09 15:20:40', NULL, NULL, '192.168.0.105', '收费查询分页列表-excel导出', 'admin', '[\"a.id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (127, NULL, '2020-08-09 15:24:04', 0, b'0', '2020-08-09 15:24:04', NULL, NULL, '192.168.0.105', '登录', 'admin', '[{\"code\":\"string\",\"sessionId\":\"string\",\"password\":\"admin\",\"username\":\"admin\"}]');
INSERT INTO `energy_log` VALUES (128, NULL, '2020-08-09 15:24:27', 0, b'0', '2020-08-09 15:24:27', NULL, NULL, '192.168.0.105', '收费查询分页列表-excel导出', 'admin', '[\"a.id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (129, NULL, '2020-08-09 17:02:07', 0, b'0', '2020-08-09 17:02:07', NULL, NULL, '127.0.0.1', '登录', 'admin', '[{\"code\":\"string\",\"sessionId\":\"string\",\"password\":\"admin\",\"username\":\"admin\"}]');
INSERT INTO `energy_log` VALUES (130, NULL, '2020-08-09 17:02:33', 0, b'0', '2020-08-09 17:02:33', NULL, NULL, '127.0.0.1', '退费查询分页列表', 'admin', '[10,1,\"a.id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (131, NULL, '2020-08-09 17:03:25', 0, b'0', '2020-08-09 17:03:25', NULL, NULL, '127.0.0.1', '收费查询分页列表-excel导出', 'admin', '[\"a.id\",\"asc\"]');
INSERT INTO `energy_log` VALUES (132, NULL, '2020-08-09 20:24:39', 0, b'0', '2020-08-09 20:24:39', NULL, NULL, '127.0.0.1', '登录', 'admin', '[{\"code\":\"string\",\"sessionId\":\"string\",\"password\":\"admin\",\"username\":\"admin\"}]');
INSERT INTO `energy_log` VALUES (133, NULL, '2020-08-09 20:27:35', 0, b'0', '2020-08-09 20:27:35', NULL, NULL, '127.0.0.1', '收费台账分页列表', 'admin', '[10,1]');
INSERT INTO `energy_log` VALUES (134, NULL, '2020-08-09 20:31:59', 0, b'0', '2020-08-09 20:31:59', NULL, NULL, '127.0.0.1', '登录', 'admin', '[{\"code\":\"string\",\"sessionId\":\"string\",\"password\":\"admin\",\"username\":\"admin\"}]');
INSERT INTO `energy_log` VALUES (135, NULL, '2020-08-09 20:32:16', 0, b'0', '2020-08-09 20:32:16', NULL, NULL, '127.0.0.1', '收费台账分页列表', 'admin', '[10,1]');
INSERT INTO `energy_log` VALUES (136, NULL, '2020-08-09 20:34:26', 0, b'0', '2020-08-09 20:34:26', NULL, NULL, '127.0.0.1', '登录', 'admin', '[{\"code\":\"string\",\"sessionId\":\"string\",\"password\":\"admin\",\"username\":\"admin\"}]');
INSERT INTO `energy_log` VALUES (137, NULL, '2020-08-09 20:34:59', 0, b'0', '2020-08-09 20:34:59', NULL, NULL, '127.0.0.1', '收费台账分页列表', 'admin', '[\"3\",\"2020\",10,1]');
INSERT INTO `energy_log` VALUES (138, NULL, '2020-08-09 20:35:13', 0, b'0', '2020-08-09 20:35:13', NULL, NULL, '127.0.0.1', '收费台账分页列表', 'admin', '[\"3\",\"2020\",10,2]');
INSERT INTO `energy_log` VALUES (139, NULL, '2020-08-09 20:35:18', 0, b'0', '2020-08-09 20:35:18', NULL, NULL, '127.0.0.1', '收费台账分页列表', 'admin', '[\"3\",\"2020\",2,1]');
INSERT INTO `energy_log` VALUES (140, NULL, '2020-08-09 20:35:27', 0, b'0', '2020-08-09 20:35:27', NULL, NULL, '127.0.0.1', '收费台账分页列表', 'admin', '[\"3\",\"2020\",5,2,1]');
INSERT INTO `energy_log` VALUES (141, NULL, '2020-08-09 20:36:22', 0, b'0', '2020-08-09 20:36:22', NULL, NULL, '127.0.0.1', '收费台账分页列表', 'admin', '[\"3\",\"2020\",5,2,1]');
INSERT INTO `energy_log` VALUES (142, NULL, '2020-08-09 20:38:11', 0, b'0', '2020-08-09 20:38:11', NULL, NULL, '127.0.0.1', '登录', 'admin', '[{\"code\":\"string\",\"sessionId\":\"string\",\"password\":\"admin\",\"username\":\"admin\"}]');
INSERT INTO `energy_log` VALUES (143, NULL, '2020-08-09 20:38:23', 0, b'0', '2020-08-09 20:38:23', NULL, NULL, '127.0.0.1', '收费台账分页列表', 'admin', '[\"3\",\"2020\",5,2,1]');
INSERT INTO `energy_log` VALUES (144, NULL, '2020-08-09 20:40:22', 0, b'0', '2020-08-09 20:40:22', NULL, NULL, '127.0.0.1', '收费台账分页列表', 'admin', '[\"3\",\"2020\",5,10,1]');
INSERT INTO `energy_log` VALUES (145, NULL, '2020-08-09 20:45:26', 0, b'0', '2020-08-09 20:45:26', NULL, NULL, '127.0.0.1', '收费台账分页列表', 'admin', '[\"2020\",10,1]');
INSERT INTO `energy_log` VALUES (146, NULL, '2020-08-09 20:45:39', 0, b'0', '2020-08-09 20:45:39', NULL, NULL, '127.0.0.1', '收费台账分页列表', 'admin', '[\"3\",\"2020\",10,1]');
INSERT INTO `energy_log` VALUES (147, NULL, '2020-08-09 20:47:09', 0, b'0', '2020-08-09 20:47:09', NULL, NULL, '127.0.0.1', '收费台账分页列表', 'admin', '[\"3\",\"2020\",10,1]');
INSERT INTO `energy_log` VALUES (148, NULL, '2020-08-09 20:48:52', 0, b'0', '2020-08-09 20:48:52', NULL, NULL, '127.0.0.1', '登录', 'admin', '[{\"code\":\"string\",\"sessionId\":\"string\",\"password\":\"admin\",\"username\":\"admin\"}]');
INSERT INTO `energy_log` VALUES (149, NULL, '2020-08-09 20:49:14', 0, b'0', '2020-08-09 20:49:14', NULL, NULL, '127.0.0.1', '收费台账分页列表', 'admin', '[\"3\",\"2020\",10,1]');
INSERT INTO `energy_log` VALUES (150, NULL, '2020-08-09 20:49:33', 0, b'0', '2020-08-09 20:49:33', NULL, NULL, '127.0.0.1', '收费台账分页列表', 'admin', '[\"3\",\"2020\",5,10,1]');
INSERT INTO `energy_log` VALUES (151, NULL, '2020-08-09 20:55:44', 0, b'0', '2020-08-09 20:55:44', NULL, NULL, '127.0.0.1', '登录', 'admin', '[{\"code\":\"string\",\"sessionId\":\"string\",\"password\":\"admin\",\"username\":\"admin\"}]');
INSERT INTO `energy_log` VALUES (152, NULL, '2020-08-09 20:56:04', 0, b'0', '2020-08-09 20:56:04', NULL, NULL, '127.0.0.1', '收费台账分页列表-excel导出', 'admin', '[]');
INSERT INTO `energy_log` VALUES (153, NULL, '2020-08-09 20:56:20', 0, b'0', '2020-08-09 20:56:20', NULL, NULL, '127.0.0.1', '收费台账分页列表-excel导出', 'admin', '[\"3\",\"2020\"]');
COMMIT;

-- ----------------------------
-- Table structure for energy_operationfee_charge
-- ----------------------------
DROP TABLE IF EXISTS `energy_operationfee_charge`;
CREATE TABLE `energy_operationfee_charge` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `company_id` bigint(20) DEFAULT NULL,
  `create_date` datetime NOT NULL,
  `energy_type` int(11) DEFAULT NULL,
  `is_del` bit(1) NOT NULL,
  `modify_date` datetime NOT NULL,
  `operator_id` bigint(20) DEFAULT NULL,
  `charge_type` int(11) NOT NULL,
  `fee` decimal(21,6) NOT NULL,
  `has_invoice` int(11) NOT NULL,
  `operatingfee_settlement_type` int(11) NOT NULL,
  `pay_time` datetime DEFAULT NULL,
  `paychannel` int(11) NOT NULL,
  `paystate` int(11) NOT NULL,
  `payway` int(11) NOT NULL,
  `rece_number` varchar(255) DEFAULT NULL,
  `yuer` decimal(19,2) DEFAULT NULL,
  `areaarchives` bigint(20) NOT NULL COMMENT 'energy_area_archives 表id',
  PRIMARY KEY (`id`),
  KEY `FKF48C3FA9F926114` (`areaarchives`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of energy_operationfee_charge
-- ----------------------------
BEGIN;
INSERT INTO `energy_operationfee_charge` VALUES (1, NULL, '2020-07-08 09:42:14', 0, b'0', '2020-07-08 14:24:49', 1, 0, -200000.000000, 0, 0, '2020-07-08 14:24:49', 0, 1, 0, 'SJBH20200708142437', 2780.00, 1);
INSERT INTO `energy_operationfee_charge` VALUES (2, NULL, '2020-07-08 14:22:43', 0, b'0', '2020-07-08 14:32:28', 1, 0, -100.000000, 1, 0, '2020-07-08 14:22:43', 0, 1, 0, 'SJBH20200708142231', 100.00, 9);
INSERT INTO `energy_operationfee_charge` VALUES (3, NULL, '2020-07-08 14:33:36', 0, b'0', '2020-07-08 14:34:13', 1, 0, -15.000000, 1, 0, '2020-07-08 14:33:36', 0, 1, 0, 'SJBH20200708143330', 15.00, 6);
INSERT INTO `energy_operationfee_charge` VALUES (4, NULL, '2020-07-09 16:34:59', 0, b'0', '2020-07-19 20:10:34', 1, 0, -100.000000, 1, 0, '2020-07-09 16:34:59', 0, 1, 0, 'SJBH20200709163443', 200.00, 9);
INSERT INTO `energy_operationfee_charge` VALUES (5, NULL, '2020-07-09 16:42:41', 0, b'0', '2020-07-13 15:17:41', 1, 0, -300.000000, 1, 0, '2020-07-11 13:36:19', 0, 1, 0, 'SJBH20200711133611', 300.00, 5);
INSERT INTO `energy_operationfee_charge` VALUES (6, NULL, '2020-07-09 16:42:55', 0, b'0', '2020-07-09 16:42:55', 1, 1, -200.000000, 0, 0, '2020-07-09 16:42:55', 0, 1, 0, 'SJBH20200709164247', 100.00, 9);
INSERT INTO `energy_operationfee_charge` VALUES (7, NULL, '2020-07-11 13:34:52', 0, b'0', '2020-07-11 13:34:52', 1, 0, -200.000000, 0, 0, '2020-07-11 13:34:52', 0, 1, 0, 'SJBH20200711133442', 200.00, 8);
INSERT INTO `energy_operationfee_charge` VALUES (8, NULL, '2020-07-13 15:12:49', 0, b'0', '2020-07-20 10:30:21', 1, 1, 1212.000000, 0, 0, '2020-07-20 10:30:21', 0, 1, 0, 'SJBH20200720103018', 1712.00, 8);
COMMIT;

-- ----------------------------
-- Table structure for energy_param_price
-- ----------------------------
DROP TABLE IF EXISTS `energy_param_price`;
CREATE TABLE `energy_param_price` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `company_id` bigint(20) DEFAULT NULL,
  `create_date` datetime NOT NULL,
  `energy_type` int(11) DEFAULT '0',
  `is_del` bit(1) NOT NULL DEFAULT b'0',
  `modify_date` datetime NOT NULL,
  `operator_id` bigint(20) DEFAULT NULL,
  `flat_price` decimal(21,2) NOT NULL,
  `ladder_balance_date` varchar(255) DEFAULT NULL,
  `ladder_dosage` varchar(255) DEFAULT NULL,
  `ladder_type` int(11) NOT NULL,
  `peak_price` decimal(21,2) NOT NULL,
  `price_name` varchar(255) DEFAULT NULL,
  `startdate` varchar(255) NOT NULL,
  `state` int(11) NOT NULL,
  `tip_price` decimal(21,2) NOT NULL,
  `valley_price` decimal(21,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of energy_param_price
-- ----------------------------
BEGIN;
INSERT INTO `energy_param_price` VALUES (16, NULL, '2018-10-16 16:07:02', 0, b'0', '2020-07-11 13:38:07', 1, 3.00, NULL, NULL, 0, 3.00, '测试', '2018-10-16', 1, 3.00, 3.00);
INSERT INTO `energy_param_price` VALUES (17, NULL, '2018-11-13 14:29:03', 0, b'0', '2018-11-13 14:29:03', NULL, 10.00, '1', NULL, 1, 10.00, '价格二', '2018-11-14', 1, 20.00, 30.00);
INSERT INTO `energy_param_price` VALUES (18, NULL, '2018-11-13 14:29:27', 0, b'0', '2018-11-13 14:29:37', NULL, 2.00, '11', NULL, 1, 2.00, '价格一', '2018-11-13', 1, 6.00, 5.00);
INSERT INTO `energy_param_price` VALUES (19, NULL, '2019-06-19 11:26:11', 1, b'0', '2019-12-05 10:14:21', 1, 1.10, NULL, NULL, 0, 1.10, '电表价格', '2019-06-01', 1, 1.10, 1.10);
INSERT INTO `energy_param_price` VALUES (20, NULL, '2019-07-02 16:22:13', 3, b'0', '2019-07-02 16:22:13', 1, 9.00, NULL, NULL, 0, 9.00, '气表价格', '2019-07-02', 1, 9.00, 9.00);
INSERT INTO `energy_param_price` VALUES (21, NULL, '2019-08-29 13:33:08', 0, b'0', '2020-07-14 14:16:23', 1, 2.00, NULL, '[{\"dosage\":100,\"addPrice\":2},{\"dosage\":500,\"addPrice\":5},{\"dosage\":1000,\"addPrice\":8}]', 1, 2.00, '方案01', '2019-08-29', 1, 2.00, 2.00);
INSERT INTO `energy_param_price` VALUES (22, NULL, '2020-07-08 14:21:31', 0, b'0', '2020-07-08 14:22:13', 1, 10.00, NULL, NULL, 0, 10.00, 'test', '2020-07-01', 0, 10.00, 10.00);
COMMIT;

-- ----------------------------
-- Table structure for energy_permission
-- ----------------------------
DROP TABLE IF EXISTS `energy_permission`;
CREATE TABLE `energy_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL COMMENT '权限名称',
  `description` varchar(255) DEFAULT NULL COMMENT '权限描述',
  `perms` varchar(255) DEFAULT NULL COMMENT '权限标识',
  `order_num` int(3) DEFAULT '0' COMMENT '排序',
  `parent_id` int(11) DEFAULT NULL COMMENT '父级权限id',
  `depth` int(11) NOT NULL COMMENT '深度',
  `type` int(1) DEFAULT NULL COMMENT '类型   0：目录   1：菜单   2：按钮',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `modify_date` datetime DEFAULT NULL COMMENT '更新时间',
  `energy_type` int(11) DEFAULT '10' COMMENT '类型0，水表',
  `is_del` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除  0正常 1.删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of energy_permission
-- ----------------------------
BEGIN;
INSERT INTO `energy_permission` VALUES (1, '超级管理', '超级管理', 'superadmin', 4, 0, 0, 0, NULL, NULL, 0, b'0');
INSERT INTO `energy_permission` VALUES (2, '用户管理', '用户管理', 'admin', 1, 22, 2, 1, NULL, NULL, 0, b'0');
INSERT INTO `energy_permission` VALUES (3, '列表', '列表', '/admin/admin/getPageList', 0, 2, 3, 2, NULL, NULL, 0, b'0');
INSERT INTO `energy_permission` VALUES (4, '添加', '添加', '/admin/admin/add', 1, 2, 3, 2, NULL, NULL, 0, b'0');
INSERT INTO `energy_permission` VALUES (5, '编辑', '编辑', '/admin/admin/update', 2, 2, 3, 2, NULL, NULL, 0, b'0');
INSERT INTO `energy_permission` VALUES (6, '删除', '删除', '/admin/admin/delete', 3, 2, 3, 2, NULL, NULL, 0, b'0');
INSERT INTO `energy_permission` VALUES (8, '角色管理', '角色管理', 'role', 0, 1, 2, 1, NULL, NULL, 0, b'0');
INSERT INTO `energy_permission` VALUES (9, '列表', '列表', '/admin/role/getPageList', 0, 8, 3, 2, NULL, NULL, 0, b'0');
INSERT INTO `energy_permission` VALUES (10, '添加', '添加', '/admin/role/add', 1, 8, 3, 2, NULL, NULL, 0, b'0');
INSERT INTO `energy_permission` VALUES (11, '编辑', '编辑', '/admin/role/update', 2, 8, 3, 2, NULL, NULL, 0, b'0');
INSERT INTO `energy_permission` VALUES (12, '删除', '删除', '/admin/role/delete', 3, 8, 3, 2, NULL, NULL, 0, b'0');
INSERT INTO `energy_permission` VALUES (13, '系统日志', '系统日志', 'log', 3, 1, 2, 1, NULL, NULL, 0, b'0');
INSERT INTO `energy_permission` VALUES (14, '列表', '列表', '/admin/log/getPageList', 0, 13, 3, 2, NULL, NULL, 0, b'0');
INSERT INTO `energy_permission` VALUES (15, '查看详情', '查看详情', '/admin/log/get', 1, 13, 3, 2, NULL, NULL, 0, b'0');
INSERT INTO `energy_permission` VALUES (16, '清空', '清空', '/admin/log/clearAll', 2, 13, 3, 2, NULL, NULL, 0, b'0');
INSERT INTO `energy_permission` VALUES (17, '删除', '删除', '/admin/log/delete', 3, 13, 3, 2, NULL, NULL, 0, b'0');
INSERT INTO `energy_permission` VALUES (18, '日常管理', '日常管理', 'daily', 0, 0, 0, 0, NULL, NULL, 0, b'0');
INSERT INTO `energy_permission` VALUES (19, '系统管理', '系统管理', 'system', 1, 0, 0, 0, NULL, NULL, 0, b'0');
INSERT INTO `energy_permission` VALUES (20, '数据管理', '数据管理', 'data', 2, 0, 0, 0, NULL, NULL, 0, b'0');
INSERT INTO `energy_permission` VALUES (21, '统计分析', '统计分析', 'statistic', 3, 0, 0, 0, NULL, NULL, 0, b'0');
INSERT INTO `energy_permission` VALUES (22, '用户管理', '用户管理', 'user', 0, 1, 1, 0, NULL, NULL, 0, b'0');
COMMIT;

-- ----------------------------
-- Table structure for energy_role
-- ----------------------------
DROP TABLE IF EXISTS `energy_role`;
CREATE TABLE `energy_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL COMMENT '角色名称',
  `is_system` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否系统内置1是0否',
  `description` varchar(255) DEFAULT NULL COMMENT '角色描述',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `modify_date` datetime DEFAULT NULL COMMENT '更新时间',
  `energy_type` int(11) DEFAULT '0' COMMENT '类型0，水表',
  `is_del` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除 0正常 1删除',
  `company_id` bigint(20) DEFAULT NULL,
  `operator_id` bigint(20) DEFAULT NULL,
  `area_ids` varchar(255) DEFAULT NULL,
  `area_big_ids` varchar(255) DEFAULT NULL,
  `equipment_ids` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of energy_role
-- ----------------------------
BEGIN;
INSERT INTO `energy_role` VALUES (1, '超级管理员', b'1', '拥有所有权限', NULL, NULL, 0, b'0', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `energy_role` VALUES (2, 'test', b'0', 'test', NULL, NULL, 0, b'0', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `energy_role` VALUES (3, 'string2', b'0', 'string', '2020-08-06 10:51:14', '2020-08-06 11:29:10', 0, b'1', NULL, 1, '1,2', NULL, '2,3');
COMMIT;

-- ----------------------------
-- Table structure for energy_role_permission
-- ----------------------------
DROP TABLE IF EXISTS `energy_role_permission`;
CREATE TABLE `energy_role_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) NOT NULL COMMENT '角色id',
  `permission_id` int(11) NOT NULL COMMENT '权限id',
  `energy_type` int(11) DEFAULT '0' COMMENT '类型0，水表',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of energy_role_permission
-- ----------------------------
BEGIN;
INSERT INTO `energy_role_permission` VALUES (5, 2, 3, 0);
INSERT INTO `energy_role_permission` VALUES (6, 2, 14, 0);
COMMIT;

-- ----------------------------
-- Table structure for energy_sysconfig_equipmentmodel
-- ----------------------------
DROP TABLE IF EXISTS `energy_sysconfig_equipmentmodel`;
CREATE TABLE `energy_sysconfig_equipmentmodel` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `company_id` bigint(20) DEFAULT NULL,
  `create_date` datetime NOT NULL,
  `energy_type` int(11) DEFAULT '0',
  `is_del` bit(1) NOT NULL DEFAULT b'0',
  `modify_date` datetime NOT NULL,
  `operator_id` bigint(20) DEFAULT NULL,
  `equ_size` double NOT NULL,
  `equ_weight` double NOT NULL,
  `equipment_type` int(11) DEFAULT NULL,
  `memo` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `serialnumber` varchar(100) NOT NULL,
  `supplier` bigint(20) DEFAULT NULL,
  `api_key` varchar(255) DEFAULT NULL,
  `app_id` varchar(255) DEFAULT NULL,
  `equipmentnbtype` int(11) DEFAULT NULL,
  `secret` varchar(255) DEFAULT NULL,
  `device_type` varchar(255) DEFAULT NULL,
  `manufacturer_id` varchar(255) DEFAULT NULL,
  `manufacturer_name` varchar(255) DEFAULT NULL,
  `model` varchar(255) DEFAULT NULL,
  `protocol_type` varchar(255) DEFAULT NULL,
  `domain_name` varchar(255) DEFAULT NULL,
  `archives_len` int(11) DEFAULT NULL,
  `access_token` varchar(255) DEFAULT NULL,
  `down_linkurl` varchar(255) DEFAULT NULL,
  `equipmentloratype` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `supplier` (`supplier`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of energy_sysconfig_equipmentmodel
-- ----------------------------
BEGIN;
INSERT INTO `energy_sysconfig_equipmentmodel` VALUES (1, NULL, '2020-06-20 12:00:42', 0, b'0', '2020-07-10 20:19:35', 1, 10, 10, 2, NULL, '电信水表NBIOT', 'EQ20200620120011', 4, NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 7, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for energy_sysconfig_metermodel
-- ----------------------------
DROP TABLE IF EXISTS `energy_sysconfig_metermodel`;
CREATE TABLE `energy_sysconfig_metermodel` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `company_id` bigint(20) DEFAULT NULL,
  `create_date` datetime NOT NULL,
  `energy_type` int(11) DEFAULT '0',
  `is_del` bit(1) NOT NULL DEFAULT b'0',
  `modify_date` datetime NOT NULL,
  `operator_id` bigint(20) DEFAULT NULL,
  `decimal_point` int(11) DEFAULT NULL,
  `meter_agree` int(11) NOT NULL,
  `meter_cal` int(11) NOT NULL,
  `meter_memo` varchar(100) DEFAULT NULL,
  `meter_model` varchar(255) DEFAULT NULL,
  `meter_name` varchar(100) NOT NULL,
  `meter_wiring_way` int(11) NOT NULL,
  `model_serialnumber` varchar(255) DEFAULT NULL,
  `supplier` bigint(20) DEFAULT NULL COMMENT '关联energy_sysconfig_supplier id',
  `archives_type` int(11) NOT NULL,
  `capacity` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKD5DD685BC6C94369` (`supplier`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of energy_sysconfig_metermodel
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for energy_sysconfig_supplier
-- ----------------------------
DROP TABLE IF EXISTS `energy_sysconfig_supplier`;
CREATE TABLE `energy_sysconfig_supplier` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `company_id` bigint(20) DEFAULT NULL,
  `create_date` datetime NOT NULL,
  `energy_type` int(11) DEFAULT '0',
  `is_del` bit(1) NOT NULL DEFAULT b'0',
  `modify_date` datetime NOT NULL,
  `operator_id` bigint(20) DEFAULT NULL,
  `memo` varchar(100) DEFAULT NULL,
  `supplier_address` varchar(100) NOT NULL,
  `supplier_contact` varchar(100) NOT NULL,
  `supplier_email` varchar(255) DEFAULT NULL,
  `supplier_name` varchar(100) NOT NULL,
  `supplier_phone` varchar(255) DEFAULT NULL,
  `supplier_serialnumber` varchar(255) DEFAULT NULL,
  `supplier_tel` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of energy_sysconfig_supplier
-- ----------------------------
BEGIN;
INSERT INTO `energy_sysconfig_supplier` VALUES (3, NULL, '2019-06-12 10:38:37', 0, b'0', '2020-07-10 20:18:36', 1, NULL, '江苏无锡新吴区', '邹杰夫', 'jeffzou@ucskype.com', '日海智能', NULL, 'GYS20190612103805', NULL);
INSERT INTO `energy_sysconfig_supplier` VALUES (4, NULL, '2020-07-08 14:07:41', 0, b'0', '2020-07-10 18:12:06', 1, NULL, '上海市长宁区金钟路633号', '马艳霞', 'mayanxia@sunseaaiot.com', '日海物联', '13817820954', 'GYS20200708140712', NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
